| FaSapProcessQueueDetailRecord |
| EntityType | Independent |
| Logical Entity Name | FaSapProcessQueueDetailRecord |
| Default Table Name | AdSapQueue_Detail |
| Logical Only | NO |
| Definition | |
| Note |
| FaSapProcessQueueDetailRecord Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Id |
INTEGER | NO | ||
StudentEnrollmentPeriodId |
INTEGER | NO | ||
FaSapProcessQueueHeaderId |
INTEGER | NO | ||
| NewFaSapStatusId | INTEGER | YES | ||
| NewSchoolStatusId | INTEGER | YES | ||
| StudentGroupId | INTEGER | YES | ||
TermId |
INTEGER | YES | ||
| FaSapStatusNote | VARCHAR(4000) | YES | ||
| ManualActionNote | VARCHAR(255) | YES | ||
| UnitsAttempted | NUMERIC(9, 2) | YES | ||
| UnitsEarned | NUMERIC(9, 2) | YES | ||
| PrevFaSapStatusId | INTEGER | YES | ||
| SapCheckpoint | TINYINT | YES | ||
| HoursAttended | NUMERIC(11, 2) | YES | ||
| ActualPctComplete | NUMERIC(7, 2) | YES | ||
| Sequence | INTEGER | YES | ||
| FailSequenceNumber | INTEGER | YES | ||
| SapNote | CHAR(1) | YES | ||
| CumulativeGpa | NUMERIC(11, 6) | YES | ||
| CumulativeNumericAvg | NUMERIC(9, 2) | YES | ||
| TermGpa | NUMERIC(11, 6) | YES | ||
| TermNumericAvg | NUMERIC(9, 2) | YES | ||
| ManualActionFlag | CHAR(1) | YES | ||
| TaskTypeId | INTEGER | YES | ||
| AutoProcessCampus | INTEGER | YES | ||
LastModifiedUserId |
INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
| IsProcessed | BIT | YES | ||
LinkedStudentEnrollmentPeriodId |
INTEGER | YES | ||
| StudentAcademicYearPaymentPeriodId | INTEGER | YES | ||
| PaymentPeriodCount | INTEGER | YES | ||
| SapEvaluationDate | DATETIME | YES |
| FaSapProcessQueueDetailRecord Keys |
| Key Name | Key Type | Keys |
| AdSapQueue_Detail_AdSapQueue_HeaderID_N_N_IDX | Inversion Entry | FaSapProcessQueueHeaderId |
| PK_AdSapQueue_Detail_AdSapQueue_DetailID | PrimaryKey | Id |
| FaSapProcessQueueDetailRecord Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| StudentEnrollmentPeriod | Non-Identifying | One To Zero or More | StudentEnrollmentPeriodId | NO | |||
| FaSapProcessQueueHeader | Non-Identifying | One To Zero or More | FaSapProcessQueueHeaderId | NO | |||
| Term | Non-Identifying | Zero or One to Zero or More | TermId | NO | |||
| StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More | LinkedStudentEnrollmentPeriodId | NO | |||
| Staff | Non-Identifying | One To Zero or More | LastModifiedUserId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| FaSapProcessQueueDetailRecord Check Constraints |
| Check Constraint Name | CheckConstraint |